Quản lý website giới thiệu và bán điện thoại di động ASP.net
19.316 lượt xem;
- timkiem.aspx.cs
- project /
1 using System;
2 using System.Collections;
3 using System.Configuration;
4 using System.Data;
5 using System.Linq;
6 using System.Web;
7 using System.Web.Security;
8 using System.Web.UI;
9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13 using SiteUtils;
14 using System.Data.OleDb;
15 public partial class Default2 : System.Web.UI.Page
16 {
17 GioHangData gh;
18 protected void Page_Load(object sender, EventArgs e)
19 {
20 ado.ketNoi();
21 string query = "SELECT tblsanpham.masp,'chitiet.aspx?tensp='+tensp as chitiet, tblsanpham.mahang, tblsanpham.tensp, tblsanpham.gia, tblsanpham.soluong, tblsanpham.dacdiem, tblsanpham.baohanh, tblsanpham.khuyenmai, tblsanpham.kieudang, tblsanpham.phongcach, tblsanpham.anh, tblsanpham.ghichu, tblhang.tenhang FROM (tblsanpham INNER JOIN tblhang ON tblsanpham.mahang = tblhang.mahang) WHERE (tblsanpham.gia >= '" + Request.QueryString.Get(0) + "') AND (tblsanpham.gia <= '" + Request.QueryString.Get(1) + "')";
22 //AND (tblsanpham.gia < 2000000)";
23 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
24 DataSet dataset = new DataSet();
25 adapter.Fill(dataset);
26 clp1.PageSize = 12;
27 clp1.DataSource = dataset.Tables[0].DefaultView;
28 clp1.BindToControl = DataList1;
29 DataList1.DataSource = clp1.DataSourcePaged;
30
31 }
32 protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
33 {
34 ado.ketNoi();
35 Label lbg = (Label)DataList1.Items[DataList1.SelectedIndex].FindControl("Label10");
36 HyperLink hy = (HyperLink)DataList1.Items[DataList1.SelectedIndex].FindControl("HyperLink1");
37
38
39 lbg.Visible = true;
40 gh = new GioHangData();
41 DataTable tb;
42 if (Session["GioHang"] == null)
43 tb = gh.setTable();
44 else
45 tb = (DataTable)Session["GioHang"];
46 string query = "select * from tblSanPham where masp='" + hy.Text + "'";
47
48 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
49 DataTable dt = new DataTable();
50 da.Fill(dt);
51 foreach (DataRow dr in dt.Rows)
52 {
53 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
54 Session["GioHang"] = tb;
55
56 }
57 }
58 }
2 using System.Collections;
3 using System.Configuration;
4 using System.Data;
5 using System.Linq;
6 using System.Web;
7 using System.Web.Security;
8 using System.Web.UI;
9 using System.Web.UI.HtmlControls;
10 using System.Web.UI.WebControls;
11 using System.Web.UI.WebControls.WebParts;
12 using System.Xml.Linq;
13 using SiteUtils;
14 using System.Data.OleDb;
15 public partial class Default2 : System.Web.UI.Page
16 {
17 GioHangData gh;
18 protected void Page_Load(object sender, EventArgs e)
19 {
20 ado.ketNoi();
21 string query = "SELECT tblsanpham.masp,'chitiet.aspx?tensp='+tensp as chitiet, tblsanpham.mahang, tblsanpham.tensp, tblsanpham.gia, tblsanpham.soluong, tblsanpham.dacdiem, tblsanpham.baohanh, tblsanpham.khuyenmai, tblsanpham.kieudang, tblsanpham.phongcach, tblsanpham.anh, tblsanpham.ghichu, tblhang.tenhang FROM (tblsanpham INNER JOIN tblhang ON tblsanpham.mahang = tblhang.mahang) WHERE (tblsanpham.gia >= '" + Request.QueryString.Get(0) + "') AND (tblsanpham.gia <= '" + Request.QueryString.Get(1) + "')";
22 //AND (tblsanpham.gia < 2000000)";
23 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
24 DataSet dataset = new DataSet();
25 adapter.Fill(dataset);
26 clp1.PageSize = 12;
27 clp1.DataSource = dataset.Tables[0].DefaultView;
28 clp1.BindToControl = DataList1;
29 DataList1.DataSource = clp1.DataSourcePaged;
30
31 }
32 protected void DataList1_SelectedIndexChanged(object sender, EventArgs e)
33 {
34 ado.ketNoi();
35 Label lbg = (Label)DataList1.Items[DataList1.SelectedIndex].FindControl("Label10");
36 HyperLink hy = (HyperLink)DataList1.Items[DataList1.SelectedIndex].FindControl("HyperLink1");
37
38
39 lbg.Visible = true;
40 gh = new GioHangData();
41 DataTable tb;
42 if (Session["GioHang"] == null)
43 tb = gh.setTable();
44 else
45 tb = (DataTable)Session["GioHang"];
46 string query = "select * from tblSanPham where masp='" + hy.Text + "'";
47
48 OleDbDataAdapter da = new OleDbDataAdapter(query, ado.con);
49 DataTable dt = new DataTable();
50 da.Fill(dt);
51 foreach (DataRow dr in dt.Rows)
52 {
53 tb = gh.dienVaoBang(tb, dr[10].ToString(), dr["TenSP"].ToString(), 1, Convert.ToDouble(dr["Gia"]), dr["masp"].ToString());
54 Session["GioHang"] = tb;
55
56 }
57 }
58 }